YEAR

Returns the year from a date value.

Syntax

YEAR(date)

Arguments

• date: The date from which to extract the year.

Example

YEAR("2025-03-02") → Returns 2025
YEAR(A1) → Returns the year from the date in cell A1